﻿CREATE TABLE [dbo].[hrm_ls_Provinces] (
    [ProvinceID]   INT            IDENTITY (1, 1) NOT NULL,
    [ProvinceCode] NVARCHAR (50)  NULL,
    [ProvinceName] NVARCHAR (150) NULL,
    CONSTRAINT [PK_hrm_ls_Provinces] PRIMARY KEY CLUSTERED ([ProvinceID] ASC)
);


GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_hrm_ls_Provinces]
    ON [dbo].[hrm_ls_Provinces]([ProvinceCode] ASC);

